﻿CREATE TABLE [Membership].[Roles] (
    [Id]   UNIQUEIDENTIFIER NOT NULL,
    [Name] NVARCHAR (256) NOT NULL,
    CONSTRAINT [PK_Membership.Roles] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [RoleNameIndex]
    ON [Membership].[Roles]([Name] ASC);

